SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475111 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475111 [ RunTime:0.003365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385700,646797,36389,809116,13016,88476,445253,785883,540661,459826,985765,296436,198047,574503,1017412,413824,800792,650377,919358,765348,127682,312396,611208,174800,269709,286794,52378,149668,773971,294383,300718,390855,429598,840081,182798,776952,234533,775630,311446,539404,348501,1012235,676928,614821,239071,17593,479186,615804,1038135,766133,596281,565001,463223,516568,814015,604576,836676,607614,560737,1024011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]