SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403169 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403169 [ RunTime:0.002016s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728720,181896,879053,1046735,668675,624714,986863,977183,509668,761021,487327,14852,433711,596681,608977,673808,1043282,595911,645541,239891,55087,8095,550432,71984,716257,715258,161356,481311,815332,645346,188868,678111,133301,369630,688703,274851,1020976,1012149,221065,7392,791246,969077,431263,198970,993784,439049,44614,276168,318020,148221,377758,974814,513507,399189,854225,157548,809024,609218,172522,225494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000728s ]