SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 186943 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 186943 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447042,930767,393596,811882,779935,51395,226223,1032955,151025,56595,106822,141420,210195,592729,1034414,311966,327053,811092,965249,984309,527541,250315,50665,356848,531067,274884,724895,317316,882354,153179,1029225,720596,582299,350475,409888,967174,1029398,1000446,714493,376814,711985,323154,608484,42436,347850,239202,886701,977048,266456,73632,144328,546803,910712,552661,1018438,226341,610023,512166,310435,205231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 186943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 186943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]