SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901061 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901061 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415731,897333,839922,176232,507884,1000587,932814,963002,999493,607993,436196,317210,666210,980973,508208,744205,648210,736638,857469,703833,500732,706613,867260,335991,70259,779413,945831,454414,21245,451913,427024,155711,433160,986177,573069,635759,528805,404294,1015665,806124,984762,677289,152196,685652,296181,34358,649542,153719,635075,478027,59313,168972,67612,903928,989897,985943,512684,441332,675086,907346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]