SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 270412 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 270412 [ RunTime:0.002240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929523,745010,497010,268541,576642,157710,76488,693779,999941,337889,452714,76350,242077,265976,263012,368439,997557,761393,585169,191449,18062,617551,633344,181336,449316,380019,376804,420858,603239,531328,1006332,86964,155312,1003531,801932,232071,522064,371139,498829,810489,840714,802764,450392,582782,126905,902787,328186,224441,177569,605461,366671,786317,514177,477485,681915,473317,605113,125315,920251,1006983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 270412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 270412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]