SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261088 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261088 [ RunTime:0.002924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568373,176983,171358,229786,181269,267414,832659,645169,324996,803977,16381,186457,797233,308985,863010,565091,177060,304264,201521,831619,998707,320628,1019768,534711,455596,947985,790089,451487,492923,5336,1004491,477467,775529,810267,118565,797978,307197,905752,975412,25778,269199,158766,302388,628724,348944,928426,60435,854291,841848,640129,378441,313776,783305,53542,337869,133283,395586,429267,571461,931645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000365s ]