SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036678 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036678 [ RunTime:0.004926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955947,804125,261404,15566,253353,371549,161839,962281,668671,936166,84923,472205,609857,104813,345208,717212,103558,774082,670608,507790,324053,478017,806584,889097,130144,623100,32959,209590,838149,548986,578838,887749,1017600,145135,430597,839964,696099,805472,368846,914748,684088,928371,375197,663861,578714,492199,46879,29121,275370,115179,284142,744831,741682,704753,624069,155435,1012813,360377,583399,962925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]