SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107892 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107892 [ RunTime:0.002252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407581,484661,692211,456790,363661,863093,274710,84755,291786,54444,925226,885759,1039758,656199,552048,322615,626290,864456,1004096,172402,198898,714513,861374,223558,410661,643754,946406,1014850,803992,643779,335901,228192,432189,604498,474641,866138,129221,845362,615478,996584,859343,864370,486334,411945,578084,230522,345121,336706,372359,100957,98666,99189,68015,910923,752213,705639,536854,644601,6649,516891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]