SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310748 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310748 [ RunTime:0.003023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325787,156296,885135,676084,877102,827958,632866,739549,849284,356676,395403,694319,176332,478981,130590,387445,851498,220985,665437,537519,365233,364229,588349,316424,63094,355998,595804,45647,507659,587729,533103,1033662,312610,789870,54995,608198,925596,1001751,1028502,1015749,388667,261219,1018420,847010,1010491,758652,634553,598801,844808,241781,141254,386711,705996,914273,785893,366167,262067,926902,515549,391671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]