SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 917913 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 917913 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189482,598533,164914,985664,719642,645893,534037,805804,44904,503029,1026604,977425,591468,605218,849913,296808,876253,807786,1024534,263861,25157,56835,834327,12533,524366,751333,701134,753480,70844,672289,521026,501494,334502,110673,146694,951210,323269,410102,739644,407514,312110,582577,1008464,232216,69357,653674,435983,661214,604802,989404,206317,618670,553844,83201,551945,377482,992288,386827,300071,233494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 917913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 917913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000773s ]