SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805343 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805343 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324910,361085,874217,522095,507902,554418,924305,326188,603275,166576,273313,764733,819039,284137,977349,468740,333949,587727,748427,267739,691265,438152,920358,493173,768530,841845,658358,894234,296745,1019059,445605,174973,1093,287797,804541,29411,754621,861413,117404,773814,999377,857536,133545,518909,1045343,340881,718767,47280,631596,226120,873696,577830,854514,312065,765115,412329,912001,413416,250953,542607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003872s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001295s ]