SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974816 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974816 [ RunTime:0.004959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792851,118225,169126,816474,521000,220210,333286,1013049,367132,620913,676753,988762,170253,675362,910876,287344,1040999,431869,390329,526139,290196,317452,85081,747181,228293,196300,598150,853181,583470,529244,697632,359929,644568,655550,1010872,471833,12113,744817,514450,496216,862121,398401,614651,412081,127527,77166,376850,654151,737812,150851,264766,563933,373173,858888,741474,607254,863837,1947,444164,170503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]