SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 147201 LIMIT 1 [ RunTime:0.002140s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 147201 [ RunTime:0.003658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126450,110596,464402,264379,874186,724809,163504,524901,753475,304738,792581,666429,469786,1038769,483377,273174,409539,556898,863539,963657,18478,840691,248162,584929,829416,628031,472992,237626,428864,87913,927044,720159,210204,1004163,444425,441041,489842,228482,936331,799200,162344,686044,978324,627357,923080,191886,193546,320990,520015,838337,750552,385641,548077,645066,155897,854597,979603,449688,496559,152843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 147201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 147201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]