SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597717 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597717 [ RunTime:0.002242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671071,504362,341364,1011525,401819,302755,662489,655134,731391,333859,723631,121387,890983,576190,581674,768273,441800,6428,274377,965721,463886,418913,198013,1018188,893897,125651,313641,273101,284040,545216,609759,487710,186280,643241,738362,333080,595550,213769,766362,526511,505980,769376,172102,46934,436035,1009608,375589,19392,909744,598890,396404,163234,985718,489724,967859,788231,722956,202998,219009,420711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]