SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53180 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53180 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751726,908623,509122,647354,454575,801427,634526,984207,69271,648417,569613,765217,793703,410620,732475,164404,859523,2334,865758,82769,722810,361209,910330,199873,228009,437152,633128,785513,210738,471145,478429,331400,50073,847881,659862,935825,616239,417021,164062,73885,309278,661526,338291,592757,1013831,931495,827397,336148,845095,551155,333672,124703,706680,511629,420418,112928,483638,877776,937925,152789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]