SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001775 LIMIT 1 [ RunTime:0.000574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001775 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622179,791095,962518,642106,251654,284336,908778,831611,939351,804257,558580,141042,220132,872288,335576,345041,50479,229148,454406,612236,953590,512427,321576,911645,1024348,435370,749703,75240,889761,55110,365917,636405,541628,253932,343200,429087,179467,555209,783966,962797,813698,702521,696012,957494,916874,523266,522921,274437,859128,850016,141021,743383,785408,867493,441657,36930,318136,343204,365859,4854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001775 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001775 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]