SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 941996 LIMIT 1 [ RunTime:0.000629s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 941996 [ RunTime:0.004546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309854,941210,246045,475679,830083,160090,278859,117096,512859,680679,678895,508056,796334,1042144,986616,178070,962283,678331,801732,276378,823413,436273,579732,334939,445602,53600,824484,86057,434724,383309,346679,150190,719111,606933,148958,789349,857169,1016471,787686,979257,507439,281629,41547,886254,1044878,465513,63349,759825,475144,107126,706081,58668,638477,931823,854493,514187,33077,101474,822920,314645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 941996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 941996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000713s ]