SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017279 LIMIT 1 [ RunTime:0.000752s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017279 [ RunTime:0.001358s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250292,340979,102519,142239,695964,541596,397672,175472,478137,325417,590662,802514,274366,742084,3200,576538,348740,205734,169872,488044,198766,296125,2333,77761,845324,191488,489662,463040,351116,629559,713556,759583,797474,532850,697383,1024049,852320,235305,733987,655611,86933,698782,678517,891059,514566,685139,576494,593528,631303,169473,881931,502681,894179,1014702,514381,541130,378137,632048,208423,1009719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017279 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017279 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]