SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58701 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58701 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119714,471717,739227,883195,464218,193516,432331,531082,305808,204985,572896,645044,220734,1035912,758103,204901,611898,1032280,913756,828130,323217,163081,717416,377082,185728,62189,802849,568037,630268,34625,865200,310551,344807,59050,693381,19912,963142,631467,938900,332216,332996,519404,868843,996572,483013,872323,11553,844967,28537,997464,804733,1024419,859787,1024563,638172,499329,656790,549941,528102,561555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]