SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501563 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501563 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40289,314778,862296,272725,771117,436253,864557,66561,647838,369132,350088,653723,909377,921642,944410,162782,614978,581232,221388,973463,418778,526815,864500,1021868,797262,1027816,250373,725011,592255,737999,383173,327458,593171,147539,692725,44096,1040775,655821,850425,115465,966684,42735,28817,892798,398704,556796,681972,769530,827093,268431,57746,320730,540833,695707,495317,102972,957718,321257,178866,359426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]