SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438904 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438904 [ RunTime:0.002249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583346,406805,947197,443044,455954,224264,944337,465303,630600,2520,932615,980457,996593,1038596,949462,767870,459896,598694,276796,785483,903826,889966,872022,82134,611919,532373,229033,605796,358224,535691,720106,489521,997073,479089,311589,122509,1002640,985439,137620,288293,92893,79937,298056,746724,129686,673688,174279,321336,199063,543653,773203,771485,741107,754482,482837,704856,306912,402850,946302,228834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]