SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036139 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036139 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395792,233431,196638,169693,929981,676308,271968,361215,583578,383046,77394,688140,333317,463567,661231,257501,51917,524758,578652,640051,749217,242347,178049,1021082,635939,793998,801960,389805,258816,866069,921262,797117,479480,190983,705347,365509,795153,1048836,811178,1022219,794969,713346,308327,359457,907779,868305,616787,790312,293549,1010334,938837,799543,75132,385823,274135,821041,1027329,533164,866481,240471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]