SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018387 LIMIT 1 [ RunTime:0.000835s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018387 [ RunTime:0.002726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506812,101618,490028,977885,48203,480980,39020,794453,177565,296640,928985,502016,362898,993742,762091,610116,180403,675984,311477,63662,386683,936102,447279,18963,507660,410840,86872,384106,865078,487182,502592,277212,635256,552750,689532,71990,477396,157784,915231,78851,302233,648529,221416,1038101,977930,729366,533672,999485,736452,706014,521849,916918,977569,41672,13379,209997,769897,550008,51086,732488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001795s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018387 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018387 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]