SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198643 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198643 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175318,911328,654859,346899,786343,591411,248259,819560,480367,135818,845572,936599,580451,884156,731417,932288,806167,1046275,908567,357800,491473,179286,86251,183980,25533,300160,980462,259053,464908,455118,633481,70580,308215,231167,176113,465011,179946,859163,88833,810762,997630,303904,249588,258038,210776,684610,930150,368434,835302,961453,37020,566266,1029954,126502,747450,891062,488862,517337,491029,794835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]