SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110204 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110204 [ RunTime:0.002563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840776,260909,55124,794425,1010530,530500,892659,861096,240904,333152,877770,163863,771632,431681,227509,117054,753899,139560,483573,562585,739860,630171,404230,202726,903925,915444,846431,629650,133698,598834,879646,104086,76037,574390,834657,225590,53652,201212,261916,98743,660551,33616,488349,344737,811081,1039405,201802,869799,31936,152983,651168,392452,487527,305277,491242,767840,785536,553981,447797,883380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000784s ]