SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311458 LIMIT 1 [ RunTime:0.000549s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311458 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257918,272378,1028872,691318,698527,666511,776968,428937,503168,323969,856666,297167,381225,1021804,561590,364499,988322,699365,365588,604724,307998,800812,163352,346263,315418,485267,290186,342861,738338,457307,228943,1001196,422476,909614,736350,824506,166519,470655,143902,901318,856425,499134,640522,142373,109567,132061,545896,716148,1006297,331969,134119,867549,137231,1004680,565384,547325,413970,48812,926863,990796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]