SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513160 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513160 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483245,138404,656930,319342,816998,606031,1023413,618637,404312,320269,740255,315471,64689,155721,381925,877375,612659,617421,191513,122229,983690,101603,58200,879145,182885,269175,63940,968426,44035,658444,731468,941389,260867,21644,563102,763746,543925,622668,223108,500580,651367,244432,7819,903522,600407,865300,967090,653283,149418,968336,582067,256730,544099,54270,888349,645980,336601,599378,526167,257652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001101s ]