SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447008 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447008 [ RunTime:0.001620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515520,959018,16450,138013,277583,123556,529356,23276,475878,46710,398765,254285,671092,739671,805914,351353,117980,755200,403531,147670,1024345,564407,69948,966119,107854,585466,844202,270604,459946,906453,924062,916498,1011394,879786,840088,640209,905297,388585,809440,201261,162495,67299,281206,930971,749543,544427,924347,950874,691955,139387,755155,710168,897477,36671,947631,177817,552939,548835,537458,647793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]