SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528905 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528905 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903826,391490,611753,627032,709620,961620,791489,254328,291266,372177,391269,604061,818109,986943,793660,105417,401255,802330,318990,227141,136758,113566,119278,578678,658332,1016270,242405,246698,645189,970324,474659,713774,704010,686162,408794,175973,319244,615927,337239,455919,634936,1042846,65393,585453,142059,446594,305716,527233,913654,792212,380074,108273,325417,24696,662943,953775,774256,833841,332161,741731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]