SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442416 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442416 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81133,388271,341491,464850,579376,117364,170175,718224,665742,103956,590690,129674,125972,830724,481484,73727,1025606,14737,364154,989293,908338,319343,1001868,735276,543871,233676,439545,232496,691159,589282,280852,516424,480757,67830,799653,966098,401911,915714,22874,631327,57584,668340,633353,185718,351623,161955,950960,397166,269535,348459,164991,103111,522363,748738,607248,1047497,59752,899957,756884,195840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]