SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038100 LIMIT 1 [ RunTime:0.000677s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038100 [ RunTime:0.004161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12005,381264,706459,236511,682803,13117,954783,958602,937553,442914,366323,713606,1022773,221781,536767,399427,89512,368713,994708,1015400,577105,142145,383677,504342,304953,328506,1014289,393977,342106,651343,318855,838363,57259,391207,162665,243149,879690,844378,200985,1041139,715159,573730,809378,861978,16133,187976,967267,911492,475909,882299,426134,582992,171910,412135,830667,83766,495913,375193,397166,158225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002742s ]