SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001560s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007893 LIMIT 1 [ RunTime:0.000903s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007893 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322965,362494,492159,562635,762942,863000,994965,1011963,904516,1047881,913255,814455,747116,150188,372735,2793,743187,227747,228954,681845,848318,783409,259569,1018937,898212,203285,573251,920826,769723,850908,154898,162429,776556,267427,279227,754580,24828,840813,304350,579288,637131,340587,574590,34709,972532,6288,195206,767448,968638,1028402,988743,705282,26678,498392,928007,776890,651994,365666,912934,57266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001355s ]