SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 940618 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 940618 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378699,2912,307712,894905,966332,92741,686798,402013,15777,64791,312891,385871,342133,580917,978571,470921,809799,985402,750385,138736,789460,194250,874202,619480,535504,1034482,156534,676007,230566,384645,903416,853427,394598,776697,161787,780724,640111,991596,270476,242306,645882,824450,257175,680897,484639,129290,850021,605445,222928,709735,564621,868661,484034,950579,265322,745949,1004685,198372,666371,838479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 940618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 940618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000801s ]