SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026169 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026169 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278185,645335,854852,671629,87681,32521,229540,863218,467871,986480,273062,972128,928130,610115,1025531,662831,580731,203028,748558,1008006,32472,738767,656102,321071,432050,484198,997059,482702,219826,895103,801495,773748,873806,152823,80567,202891,1683,448973,862073,281447,518221,205972,687386,61061,711614,198344,819724,627085,1023463,221405,377121,739154,886674,298246,159676,323014,557942,172414,15895,575529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]