SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001801s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532324 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532324 [ RunTime:0.002280s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604041,989773,537502,282303,979616,622580,188436,102593,79754,431379,1020207,1042005,472776,589869,656054,762147,700719,103424,69562,525992,746958,251391,157083,447708,802761,83546,415765,1032099,844431,141214,327013,290936,71361,567700,143065,727478,937864,1040836,377800,515648,973005,1017001,549576,413971,526675,499760,77277,745948,719312,361112,1032068,571556,157434,974252,866349,789796,850399,145786,780008,1048614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]