SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036826 LIMIT 1 [ RunTime:0.000620s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036826 [ RunTime:0.002562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20186,620005,937449,904434,776251,699135,223312,590382,605021,857451,218996,770872,84978,1002644,130815,530184,851550,36548,902378,131370,471887,791039,501348,484444,191612,622288,524530,333140,598638,446469,732613,334044,54453,430280,962431,655817,45826,329241,737199,1021069,1036678,785273,873293,391580,54423,257290,404932,381088,911746,1007403,220656,156145,337588,548930,970679,18492,621683,178595,612237,721542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005804s ]