SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475105 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475105 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265128,1010545,237679,5463,569987,1020303,788336,1026622,686927,936538,150518,588876,641383,117392,922989,354885,216426,285191,555635,143792,980730,714438,386039,585765,777809,686635,1005075,639354,449706,740298,947801,349640,591310,194585,955914,171757,81050,398141,827132,599788,549916,1024261,504349,797035,206279,838848,215340,544166,874890,709820,305125,199824,450572,917758,167305,69537,616885,520762,764317,271335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]