SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003985s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520663 LIMIT 1 [ RunTime:0.001024s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520663 [ RunTime:0.006883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894884,510797,448238,658757,293662,579825,253069,133376,905069,623378,462158,336612,378708,724065,638825,395714,34323,281583,563954,674934,552026,521917,1039951,661820,840590,31713,758315,719915,371325,607788,264943,1005706,914384,321491,1015909,445285,286898,555860,177851,259720,1026962,138981,194031,519105,805080,1001552,213509,428064,255182,236999,529013,735054,1032429,789039,838733,465405,67412,236739,456310,555518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000839s ]