SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576071 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576071 [ RunTime:0.002412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551422,730845,87913,319229,506424,342668,648984,436681,1004452,983544,142191,930456,437387,904572,941743,49384,369393,772886,295384,57916,416217,891440,7892,120491,139921,393741,577327,195144,542086,178187,453771,737243,588096,976360,700370,133353,401967,476017,358940,550239,780101,168681,828341,69486,404982,412450,672670,210364,488669,870007,925252,6315,63661,185391,629426,269467,1008890,230087,441822,1003044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]