SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583301 LIMIT 1 [ RunTime:0.000672s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583301 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66776,427285,388745,465113,817099,1027374,366163,952837,563001,978360,248437,596684,536561,445432,312049,439590,903116,456690,850344,138436,339948,461984,920316,604042,961628,742834,211846,279769,347839,808232,516084,499761,210677,753949,193809,163435,830163,417748,200965,691325,558456,329928,529847,558747,57993,730474,998535,692795,405689,784918,542372,517180,566001,523191,646107,755137,1026461,958507,289750,273424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]