SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043199 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043199 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620621,626526,955058,58917,995340,226080,260783,700565,833979,375415,279105,769855,556691,283178,371731,441955,889830,103416,238442,403065,950818,334447,563811,183890,543238,257446,378319,864257,513346,772302,1030814,343903,942857,468723,938711,734894,547842,1033645,323923,288117,774974,869401,678460,659462,928087,758927,176685,545308,10010,398107,834062,407154,320713,479023,958528,204484,207441,1044534,270641,512382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]