SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410743 LIMIT 1 [ RunTime:0.002593s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410743 [ RunTime:0.004768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54417,965968,400688,664440,403962,940982,246173,595341,193184,379414,765810,237908,101377,401699,185510,302373,593037,276247,466062,411311,37543,218173,343532,39497,325195,415612,682833,639495,538022,858497,647328,1026240,768677,394132,354640,1039162,74272,680367,821428,940002,590622,836285,260721,456350,134156,186619,182038,552110,740872,1009005,572770,582750,608474,997159,13025,697684,259242,161543,585218,594061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]