SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 621048 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 621048 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285295,67955,199864,63328,1023272,840867,472294,453492,926047,485468,96688,970983,480289,384688,717533,831860,355496,18190,1034811,79572,981735,525824,554551,543399,841240,249903,85243,474958,801928,842060,472049,946541,108341,192668,1014257,273664,690255,103881,1003280,279824,795555,721573,531193,539146,83145,35284,500906,331644,766734,865709,126751,511454,621826,16093,826679,791632,324644,30736,574859,152421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 621048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001764s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 621048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]