SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541437 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541437 [ RunTime:0.004814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154853,842009,259053,39080,121427,301857,281901,123947,1003414,887432,390290,188258,677786,959905,842346,888956,693319,802636,312967,415389,714167,966352,767464,144609,379805,358662,228387,543548,115053,437897,965395,53690,749537,732843,339330,894803,517398,175187,311019,607348,335843,893726,861935,196308,24922,390784,982819,975,193566,573128,808001,342305,641988,200916,759821,1026396,174953,837711,383203,5540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001415s ]