SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108781 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108781 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314437,294795,298641,828479,494605,170244,1003679,225843,1000002,947585,669923,487383,808350,713077,448405,81334,364839,1044355,326070,566970,443076,147357,136577,300187,294102,623635,329837,203367,238402,335589,242823,309715,633724,431388,647987,845531,778491,915346,1028608,230121,316533,964231,922826,755254,804842,183702,721438,899531,98463,1029153,435825,295952,904209,554176,496670,205583,89936,1035581,54277,174832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]