SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005511 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005511 [ RunTime:0.002857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647423,316823,333765,510957,864709,576427,987570,1038720,710017,529862,711166,217792,105564,51187,667976,431269,253602,820659,35267,789937,379133,989052,1019945,581017,688783,566627,399464,619240,128616,62616,756038,697024,415584,391783,351648,588156,140665,43622,1017841,711910,363140,572976,938905,151962,297937,748463,445405,565101,387321,993295,323958,860787,361595,664785,725536,731758,369211,43189,988298,201065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]