SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144413 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144413 [ RunTime:0.003728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299933,76383,157871,116744,665902,1046473,99435,21660,1003893,71487,768255,677794,462958,192271,304872,972712,96010,780892,828511,767007,1039644,883366,588406,117018,547954,495703,271406,414056,371090,395837,713421,85913,14743,127788,457661,434985,581058,156677,48737,982859,186095,228728,77479,373595,870434,465814,279856,313295,736916,758021,896021,506443,28595,1036123,573548,389983,325671,556714,222864,56565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]