SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44160 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44160 [ RunTime:0.004877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210968,336753,473554,45418,187553,242726,724840,150620,932175,921584,752960,994248,839933,272736,829390,516610,835996,416344,505291,635930,740857,847474,88946,95704,784721,552255,576054,338165,250256,870439,128123,798095,514651,889556,608698,225136,539711,276711,301381,699201,54267,735920,739308,985792,239055,519509,440795,471871,245737,522785,950707,485857,553720,1030128,323981,14161,229018,17140,211499,888291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]