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` = 504360 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504360 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (970545,352237,741529,432117,123204,919590,80462,131725,696873,929166,643363,1006682,583085,59021,883633,449860,876984,561802,742419,836332,545951,7306,740913,582600,114165,590853,42527,427986,940996,199015,159616,885405,863966,111986,531108,192512,467781,876432,616599,367116,222071,903080,612721,763988,214714,710179,232423,1027840,290885,883093,799689,6945,921534,488485,431377,46520,237436,73938,447739,538942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504360 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504360 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]