SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544416 LIMIT 1 [ RunTime:0.000912s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544416 [ RunTime:0.002060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007759,837126,849777,764847,859180,229887,863738,226413,872590,621613,412619,456741,72036,59315,789877,1018054,914300,886267,284170,661171,374957,5995,125096,653002,288080,143315,300367,688229,42142,31170,770166,535064,174642,817377,909342,253457,45850,514092,916680,775528,839751,414806,741441,37539,413638,881969,941509,236302,555682,479861,478797,12582,441468,131384,396023,790892,14270,193879,438706,616333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]