SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555529 LIMIT 1 [ RunTime:0.000273s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555529 [ RunTime:0.002038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881430,811703,968445,801798,132233,497297,984130,88204,105190,369879,707017,781614,886456,780345,637333,1006687,901516,517000,22313,102538,312426,689472,995710,477133,823271,436837,36551,687619,67211,918686,15497,859182,230532,205617,219837,502881,100842,371264,288448,826447,1011357,88178,312654,748342,454468,382215,766788,509127,467694,573863,604869,163181,344800,865661,338187,705451,591102,972561,395732,262201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001290s ]