SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456215 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456215 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238254,415960,902013,224888,653187,492146,591988,1037698,808501,16631,6402,121284,709582,956451,487173,1030071,484999,532504,542677,538955,130308,158327,31723,872999,978478,279370,156106,127242,4403,851545,131663,500557,880554,93580,603478,1035339,994207,387331,643644,983341,926004,926318,195922,1010785,681071,254305,407074,743391,212893,1027838,868393,810553,955274,755041,931990,730841,707444,856795,775316,361095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]