SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44438 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44438 [ RunTime:0.003023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668631,361900,193700,743320,836602,959491,988925,317362,60201,551833,202426,52715,610614,553727,604185,983735,174655,967085,135397,614886,587857,124398,159613,504332,569323,43947,584420,77329,471230,892077,846515,157123,577717,323114,412664,450286,64679,1045953,159550,970370,850650,297420,237439,16374,860787,766345,631290,876665,202774,976541,884635,797949,950074,856628,822631,866429,369307,88333,241167,370891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]