SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310042 LIMIT 1 [ RunTime:0.001465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310042 [ RunTime:0.003591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993992,387661,885602,401021,162173,471156,221111,247660,716221,41606,791146,949511,783445,511305,495558,452971,697088,320241,237459,175779,223213,798803,102925,114291,512166,634335,777214,74424,933155,761235,593520,25806,652976,855560,45888,229586,308946,115625,845002,433501,199262,358052,156588,909255,495862,31146,94557,649272,368528,426315,122470,255265,629293,687063,852504,536931,795740,276936,269542,762687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]