SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801030 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801030 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851492,363860,873078,1009946,318002,728336,224449,254620,543105,60656,778826,261627,262953,1021153,818239,259009,162407,159012,914097,958074,610574,620679,749105,938580,123197,1036904,1005448,303990,973995,865038,910965,71921,754527,417962,380302,1017284,114672,972186,970098,677963,664168,841773,376525,750553,569324,40797,868698,580072,484152,501621,876665,821722,675979,23281,637665,86255,1017060,685435,484355,197759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]