SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510198 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510198 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715148,1013745,212051,72699,360666,660831,197473,447339,436183,809000,359799,689024,8196,351477,538881,852128,945690,10112,620660,188103,311487,120712,625266,582083,511708,419285,327934,188470,745303,842050,315896,780551,989206,349760,409045,380136,539209,204293,944648,128745,745759,146504,534447,368728,807045,292923,366777,300159,710436,744759,319027,248311,429040,341363,1014777,400159,291910,43471,380710,136690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]