SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804411 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804411 [ RunTime:0.003047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492323,849689,764394,972105,387508,774565,1400,1034725,115314,5327,403637,970597,1035711,189944,806450,639994,486206,239909,906225,552978,621892,413012,225619,765602,391051,389438,715934,950435,678017,852803,941822,824041,948524,478079,667944,666123,230992,968950,806190,350173,662278,179989,988757,1005944,684462,913012,407514,158257,268755,339315,214697,506574,285963,253421,743692,776188,131634,410065,29959,658138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000972s ]