SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106246 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106246 [ RunTime:0.003781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413248,597235,150708,506391,739085,852524,210911,215702,926287,119941,277697,394528,1023112,909742,55470,127564,17808,919391,617956,165764,847878,446396,879516,619697,83790,475283,162972,227512,626920,991984,7999,821845,758975,908083,26834,327917,990143,859320,647877,289436,893826,409535,90865,561489,702052,787210,569071,311635,296034,713988,938093,63217,685252,144952,1027307,293607,468193,364406,336918,395121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]