SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438463 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438463 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914224,47682,694711,12073,967401,1047772,406931,519564,234468,91806,250073,466013,358474,419957,202828,83229,879370,686495,647263,759690,226657,63544,581236,968571,417234,755017,770830,267662,1037587,427597,1023850,29564,530524,341322,739588,53909,795891,503152,175022,393747,247272,741230,852043,1003649,160175,553100,720517,226680,195606,886042,365958,538129,511254,918933,72093,514668,1012060,1012220,853088,889745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000944s ]