SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408105 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408105 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311415,171027,394425,784604,240651,1021577,401244,825613,783451,671489,109209,338984,722716,152885,650356,278353,147920,504965,955670,761853,242409,499925,362674,646557,338882,292087,1010720,406146,894417,933308,811898,140132,342285,785955,668948,963597,39208,1031143,240098,496451,634928,1015149,927887,469579,470250,540894,389172,601454,706183,507154,956508,594550,450214,195531,324141,310419,432833,1004946,817020,71867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]