SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031572 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031572 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383983,211119,736947,781915,413791,1016630,909500,755050,251895,833745,490184,595550,785990,996132,989238,334337,187941,429212,441034,642466,1020230,349954,926006,373913,809259,1011752,167908,126046,1033106,1002085,707952,187809,972145,20190,281027,69101,1003289,662303,919673,977961,1042854,227884,255529,724163,984473,218560,1004411,458004,255273,471390,446460,321772,190229,124041,27572,246608,701330,934804,247422,579650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]