SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564458 LIMIT 1 [ RunTime:0.000589s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564458 [ RunTime:0.002908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964360,138843,148755,962761,145848,952211,842000,247830,754888,940568,67507,532459,214777,775473,954201,916438,869064,59550,307149,763420,218307,983506,295047,933243,725020,602011,531395,914732,704509,83580,294349,387603,892059,784925,954070,622133,272232,124385,1035592,244541,291933,193785,13079,496432,1030573,440815,669806,479198,745428,544190,759839,451012,147822,529661,613352,582181,717711,104712,114051,105019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000974s ]