SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474064 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474064 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929047,881446,217666,290996,327653,767938,318712,485224,897380,157511,897014,1035296,671107,184665,544035,307034,957150,45167,643414,429842,555926,787331,755354,345175,998507,651371,824243,802362,904791,296536,481181,14291,328341,428435,980556,606114,473840,644661,545779,35268,135448,482232,509990,981733,380481,500406,842485,626755,866330,900062,29908,606084,380498,859378,233630,556924,604670,267825,32113,151541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]