SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035117 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035117 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308316,901128,253455,811676,921052,1005778,733669,432897,453234,526941,271253,231255,35885,155085,603217,81554,992654,48305,1037112,14896,1013799,852479,96417,599732,944616,578035,818795,835510,586570,861863,356697,694632,61102,707922,427568,308234,336016,615231,954898,213742,977515,735843,493472,880903,21154,719588,137950,75425,668292,578338,824068,361583,138279,37551,176222,771053,80822,139409,593410,671740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002479s ]