SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418171 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418171 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745013,3689,823919,13498,185012,183826,804064,172392,465556,165972,542637,248336,869179,777994,760678,102646,541435,731515,973798,402693,657146,931633,767636,577939,220266,937468,354570,532987,842828,135241,776806,326904,758211,946970,1004199,975848,712859,301405,214207,218405,134011,828280,644567,202522,912262,536771,197529,206320,600984,393504,250670,386037,651975,423531,636718,966773,122717,591471,27509,391452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000879s ]