SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 370943 LIMIT 1 [ RunTime:0.001317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 370943 [ RunTime:0.004138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207155,29223,836793,991165,403300,894959,824606,655861,705635,43742,1042339,850992,261359,222764,547135,984805,1043400,420756,532970,174403,24877,1042425,744810,1004369,993883,629484,902637,422169,442915,192153,625031,808471,897761,550423,762929,424668,570551,24526,880737,508395,665379,704708,1018834,801915,73151,10028,271375,964237,935767,1005456,332097,769707,978893,778406,326050,407394,527966,1044374,93976,239798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 370943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 370943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001207s ]