SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402931 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402931 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86175,161807,703880,849433,786343,252664,805386,125610,678020,466972,281309,8000,418068,698578,943660,801152,839122,330600,680556,925539,542005,113309,63303,597442,318781,1044486,535182,175304,667243,790301,933420,915028,867001,849986,788541,976234,240867,886576,102479,322672,364103,877168,593872,668556,1021397,785274,417850,187710,385675,210931,394810,749483,973654,156321,1021731,414302,285979,409182,139862,888390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]