SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501197 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501197 [ RunTime:0.002355s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20731,59413,525673,662493,395268,332535,187634,487504,977009,708887,597118,767941,1033095,129411,252753,295878,974477,184171,146662,501179,954461,717658,725070,788544,517632,679738,799446,771034,176959,837986,536950,199597,95642,498769,682678,185025,346154,744306,149484,67275,188053,626202,599114,79359,289851,296365,729085,1012743,889299,473160,755384,274593,924639,123885,379118,757191,300770,281285,1026975,623380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]