SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292309 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292309 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017022,414257,576639,259579,319596,281834,1041494,742348,1044036,461756,84089,1047293,604494,451065,179337,689431,307055,871583,575205,84159,213888,36552,795802,152514,766070,52188,633333,297555,336128,906911,346528,138002,532673,302472,787212,192235,434808,734071,349433,64341,670263,881073,391801,141881,538602,459993,140237,741738,580012,541602,591197,1004787,676681,864304,436534,143328,449130,333310,733772,599164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]