SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003437 LIMIT 1 [ RunTime:0.001329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003437 [ RunTime:0.002821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806691,333087,156215,686380,370225,686754,878142,156487,317463,647450,162476,1015473,377572,686019,47495,465008,508535,266634,911036,26787,920876,724640,139594,196864,983230,397541,137376,560114,598153,499537,494213,512152,600757,112679,419225,107514,745668,60005,591334,895697,487312,1030990,76172,439878,148624,590470,48569,211488,1009448,490927,711355,674296,273264,296394,379915,935052,222815,656525,6541,313006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]