SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254544 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254544 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596937,985715,1019304,798929,232253,162129,81181,68515,841504,220338,920106,847593,797227,834582,193312,1011786,987739,659412,265838,516889,880515,252952,697454,805631,7666,134887,445409,872509,868245,876204,706059,264558,711399,409730,321558,390671,886281,26585,1510,432007,820293,340740,174026,126923,37081,856496,30404,40212,655921,254948,820927,240028,6248,100974,85364,878672,350446,583233,899338,330021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]