SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534207 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534207 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613426,848082,1020048,1017639,709181,396621,129164,261221,427230,366295,463684,586365,1029108,531523,602991,35138,104895,435610,791309,571871,998386,695087,924917,549026,670907,697540,894281,737846,295995,753260,779705,662587,726489,580898,227095,850186,502359,680344,913694,627669,978281,385126,787765,305600,760050,792696,638020,901169,665796,100157,56572,206793,587966,834438,86365,69623,486280,834662,918896,919058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001660s ]