SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289001 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289001 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006088,770773,978756,1041283,201624,995567,103572,876842,730926,455523,330279,683133,874602,974332,774662,831000,628176,600380,260002,450478,904607,269143,402052,314709,597956,910255,686559,511492,122113,981863,123058,522488,202590,717702,86920,866840,620211,598214,726919,14811,822612,365422,137026,598082,77476,852626,126496,268030,100407,233885,428876,380544,1006334,407885,822363,849070,716300,438221,181363,1021505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]