SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043931 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043931 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89017,901858,325286,88129,958401,854942,316134,196537,784199,473805,415146,2585,500283,420513,705338,842494,330056,145739,910927,313430,795693,585815,547758,802123,108038,707968,14709,387968,869945,464148,279016,649700,844027,237137,529832,230721,151014,449282,60536,306441,357807,649794,683547,582888,704962,855855,513686,688219,133910,305383,1001808,52986,768340,890430,40764,828454,87771,223404,124873,441537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]