SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316957 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316957 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593390,847605,190196,686396,437703,905440,672780,680604,310999,925643,718375,553982,71994,482156,880627,4120,223073,906087,595540,460464,274707,110863,112271,406780,679310,699579,113411,619632,848083,517298,612319,346616,1034296,795745,46890,318158,63839,679040,733530,64538,781076,522425,391730,533413,349470,684494,549310,260367,786255,788050,230975,948505,93446,759821,830036,551135,681597,933811,375635,360874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]