SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51407 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51407 [ RunTime:0.002365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549311,242242,840447,661705,821539,863454,186113,659167,92510,979289,101413,955154,136818,778187,591639,296221,773978,825691,657504,681351,527510,931598,408191,970038,410416,339843,5098,705447,402348,608860,634175,526164,871567,65053,9303,970588,1017690,955653,305848,207519,67183,553331,188948,445692,24403,194036,714372,281922,806699,189453,403831,281131,527735,276093,590749,183817,934477,314388,294368,807629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]