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` = 1046309 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046309 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702115,207269,820476,696968,293725,782027,26714,590757,1024103,991068,5247,596186,47980,370081,859367,677683,659776,606382,505652,671436,629828,270460,821007,638079,530761,977228,196456,15167,145172,235934,1026121,243324,766988,34713,1033718,1036666,265737,301768,289774,345457,911684,781880,576756,590328,1048500,828660,801953,511725,113769,66622,156651,812980,715129,413527,419184,305364,661334,955194,698657,192724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]